Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 59824 |
| Missing cells | 193408 |
| Missing cells (%) | 11.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 13.2 MiB |
| Average record size in memory | 232.0 B |
Variable types
| NUM | 17 |
|---|---|
| CAT | 10 |
| UNSUPPORTED | 1 |
| BOOL | 1 |
amenities has a high cardinality: 51780 distinct values | High cardinality |
city has a high cardinality: 133 distinct values | High cardinality |
name has a high cardinality: 58689 distinct values | High cardinality |
zipcode has a high cardinality: 474 distinct values | High cardinality |
state is highly correlated with metropolitan | High correlation |
metropolitan is highly correlated with state | High correlation |
has_availability has 59824 (100.0%) missing values | Missing |
review_scores_checkin has 14346 (24.0%) missing values | Missing |
review_scores_cleanliness has 14280 (23.9%) missing values | Missing |
review_scores_communication has 14285 (23.9%) missing values | Missing |
review_scores_location has 14349 (24.0%) missing values | Missing |
review_scores_rating has 14200 (23.7%) missing values | Missing |
review_scores_value has 14354 (24.0%) missing values | Missing |
weekly_price has 46386 (77.5%) missing values | Missing |
zipcode has 826 (1.4%) missing values | Missing |
name is uniformly distributed | Uniform |
id has unique values | Unique |
latitude has unique values | Unique |
longitude has unique values | Unique |
has_availability is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
availability_30 has 24034 (40.2%) zeros | Zeros |
bedrooms has 4964 (8.3%) zeros | Zeros |
Reproduction
| Analysis started | 2020-11-25 01:58:59.661934 |
|---|---|
| Analysis finished | 2020-11-25 01:59:45.941244 |
| Duration | 46.28 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
accommodates
Real number (ℝ≥0)
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 61 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.031959574 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 7 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.999426632 |
|---|---|
| Coefficient of variation (CV) | 0.659450294 |
| Kurtosis | 7.884614679 |
| Mean | 3.031959574 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.251525003 |
| Sum | 181199 |
| Variance | 3.997706857 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2 | 26531 | 44.3% | |
| 4 | 9665 | 16.2% | |
| 1 | 7787 | 13.0% | |
| 3 | 6538 | 10.9% | |
| 6 | 3521 | 5.9% | |
| 5 | 2719 | 4.5% | |
| 8 | 1218 | 2.0% | |
| 7 | 629 | 1.1% | |
| 10 | 459 | 0.8% | |
| 9 | 189 | 0.3% | |
| Other values (6) | 507 | 0.8% |
| Value | Count | Frequency (%) | |
| 1 | 7787 | 13.0% | |
| 2 | 26531 | 44.3% | |
| 3 | 6538 | 10.9% | |
| 4 | 9665 | 16.2% | |
| 5 | 2719 | 4.5% |
| Value | Count | Frequency (%) | |
| 16 | 164 | 0.3% | |
| 15 | 31 | 0.1% | |
| 14 | 53 | 0.1% | |
| 13 | 28 | < 0.1% | |
| 12 | 181 | 0.3% |
| Distinct | 51780 |
|---|---|
| Distinct (%) | 86.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 467.4 KiB |
| {} | 383 |
|---|---|
| {"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"} | 98 |
| {"Family/kid friendly"} | 55 |
| {TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 36 |
| {TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Heating} | 31 |
| Other values (51775) |
| Value | Count | Frequency (%) | |
| {} | 383 | 0.6% | |
| {"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"} | 98 | 0.2% | |
| {"Family/kid friendly"} | 55 | 0.1% | |
| {TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 36 | 0.1% | |
| {TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,Heating} | 31 | 0.1% | |
| {TV,Internet,"Wireless Internet","Air conditioning",Kitchen,Heating} | 28 | < 0.1% | |
| {Internet,"Wireless Internet","Air conditioning",Kitchen,Heating} | 28 | < 0.1% | |
| {TV,Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,Essentials} | 27 | < 0.1% | |
| {Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,Essentials} | 27 | < 0.1% | |
| {TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating} | 26 | < 0.1% | |
| Other values (51770) | 59085 | 98.8% |
Unique
| Unique | 47974 ? |
|---|---|
| Unique (%) | 80.2% |
Length
| Max length | 1142 |
|---|---|
| Median length | 250 |
| Mean length | 249.9386701 |
| Min length | 2 |
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.97644758 |
|---|---|
| Minimum | 0 |
| Maximum | 30 |
| Zeros | 24034 |
| Zeros (%) | 40.2% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3 |
| Q3 | 13 |
| 95-th percentile | 29 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 10.06264069 |
|---|---|
| Coefficient of variation (CV) | 1.261544138 |
| Kurtosis | -0.2423865862 |
| Mean | 7.97644758 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.07996121 |
| Sum | 477183 |
| Variance | 101.2567376 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 24034 | 40.2% | |
| 30 | 2919 | 4.9% | |
| 1 | 2388 | 4.0% | |
| 2 | 2254 | 3.8% | |
| 29 | 2197 | 3.7% | |
| 3 | 2095 | 3.5% | |
| 4 | 2016 | 3.4% | |
| 5 | 1851 | 3.1% | |
| 6 | 1655 | 2.8% | |
| 7 | 1572 | 2.6% | |
| Other values (21) | 16843 | 28.2% |
| Value | Count | Frequency (%) | |
| 0 | 24034 | 40.2% | |
| 1 | 2388 | 4.0% | |
| 2 | 2254 | 3.8% | |
| 3 | 2095 | 3.5% | |
| 4 | 2016 | 3.4% |
| Value | Count | Frequency (%) | |
| 30 | 2919 | 4.9% | |
| 29 | 2197 | 3.7% | |
| 28 | 888 | 1.5% | |
| 27 | 715 | 1.2% | |
| 26 | 487 | 0.8% |
bathrooms
Real number (ℝ≥0)
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 202 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.183447385 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros | 145 |
| Zeros (%) | 0.2% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4837264537 |
|---|---|
| Coefficient of variation (CV) | 0.4087435232 |
| Kurtosis | 23.41188858 |
| Mean | 1.183447385 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.694585316 |
| Sum | 70559.5 |
| Variance | 0.233991282 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 48779 | 81.5% | |
| 2 | 5478 | 9.2% | |
| 1.5 | 3021 | 5.0% | |
| 2.5 | 1091 | 1.8% | |
| 3 | 500 | 0.8% | |
| 3.5 | 267 | 0.4% | |
| 0 | 145 | 0.2% | |
| 4 | 122 | 0.2% | |
| 0.5 | 113 | 0.2% | |
| 4.5 | 36 | 0.1% | |
| Other values (6) | 70 | 0.1% | |
| (Missing) | 202 | 0.3% |
| Value | Count | Frequency (%) | |
| 0 | 145 | 0.2% | |
| 0.5 | 113 | 0.2% | |
| 1 | 48779 | 81.5% | |
| 1.5 | 3021 | 5.0% | |
| 2 | 5478 | 9.2% |
| Value | Count | Frequency (%) | |
| 8 | 16 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 6.5 | 3 | < 0.1% | |
| 6 | 15 | < 0.1% | |
| 5.5 | 10 | < 0.1% |
bed_type
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 467.4 KiB |
| Real Bed | |
|---|---|
| Futon | 669 |
| Pull-out Sofa | 544 |
| Airbed | 431 |
| Couch | 192 |
| Value | Count | Frequency (%) | |
| Real Bed | 57988 | 96.9% | |
| Futon | 669 | 1.1% | |
| Pull-out Sofa | 544 | 0.9% | |
| Airbed | 431 | 0.7% | |
| Couch | 192 | 0.3% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 13 |
|---|---|
| Median length | 8 |
| Mean length | 7.987881118 |
| Min length | 5 |
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 95 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.221969228 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros | 4964 |
| Zeros (%) | 8.3% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7759823495 |
|---|---|
| Coefficient of variation (CV) | 0.6350260971 |
| Kurtosis | 8.27732671 |
| Mean | 1.221969228 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.03348828 |
| Sum | 72987 |
| Variance | 0.6021486067 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 42108 | 70.4% | |
| 2 | 8655 | 14.5% | |
| 0 | 4964 | 8.3% | |
| 3 | 2901 | 4.8% | |
| 4 | 795 | 1.3% | |
| 5 | 215 | 0.4% | |
| 6 | 58 | 0.1% | |
| 7 | 14 | < 0.1% | |
| 8 | 11 | < 0.1% | |
| 10 | 5 | < 0.1% | |
| (Missing) | 95 | 0.2% |
| Value | Count | Frequency (%) | |
| 0 | 4964 | 8.3% | |
| 1 | 42108 | 70.4% | |
| 2 | 8655 | 14.5% | |
| 3 | 2901 | 4.8% | |
| 4 | 795 | 1.3% |
| Value | Count | Frequency (%) | |
| 10 | 5 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| 8 | 11 | < 0.1% | |
| 7 | 14 | < 0.1% | |
| 6 | 58 | 0.1% |
beds
Real number (ℝ≥0)
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 109 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.626107343 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.128177847 |
|---|---|
| Coefficient of variation (CV) | 0.6937905123 |
| Kurtosis | 18.65943971 |
| Mean | 1.626107343 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.270074892 |
| Sum | 97103 |
| Variance | 1.272785254 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 37940 | 63.4% | |
| 2 | 13344 | 22.3% | |
| 3 | 4730 | 7.9% | |
| 4 | 2064 | 3.5% | |
| 5 | 815 | 1.4% | |
| 6 | 433 | 0.7% | |
| 7 | 138 | 0.2% | |
| 8 | 107 | 0.2% | |
| 10 | 48 | 0.1% | |
| 9 | 35 | 0.1% | |
| Other values (7) | 61 | 0.1% | |
| (Missing) | 109 | 0.2% |
| Value | Count | Frequency (%) | |
| 0 | 4 | < 0.1% | |
| 1 | 37940 | 63.4% | |
| 2 | 13344 | 22.3% | |
| 3 | 4730 | 7.9% | |
| 4 | 2064 | 3.5% |
| Value | Count | Frequency (%) | |
| 16 | 12 | < 0.1% | |
| 15 | 3 | < 0.1% | |
| 14 | 4 | < 0.1% | |
| 13 | 6 | < 0.1% | |
| 12 | 16 | < 0.1% |
cancellation_policy
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 467.4 KiB |
| strict | |
|---|---|
| flexible | |
| moderate | |
| super_strict_30 | 172 |
| no_refunds | 1 |
| Other values (2) | 2 |
| Value | Count | Frequency (%) | |
| strict | 25278 | 42.3% | |
| flexible | 19299 | 32.3% | |
| moderate | 15072 | 25.2% | |
| super_strict_30 | 172 | 0.3% | |
| no_refunds | 1 | < 0.1% | |
| long_term | 1 | < 0.1% | |
| super_strict_60 | 1 | < 0.1% |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 15 |
|---|---|
| Median length | 8 |
| Mean length | 7.175213961 |
| Min length | 6 |
| Distinct | 133 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 46 |
| Missing (%) | 0.1% |
| Memory size | 467.4 KiB |
| new york | |
|---|---|
| brooklyn | |
| washington | |
| chicago | |
| boston | |
| Other values (128) |
| Value | Count | Frequency (%) | |
| new york | 19566 | 32.7% | |
| brooklyn | 16507 | 27.6% | |
| washington | 7741 | 12.9% | |
| chicago | 5194 | 8.7% | |
| boston | 3388 | 5.7% | |
| queens | 2692 | 4.5% | |
| denver | 2498 | 4.2% | |
| sunnysidebronx | 660 | 1.1% | |
| staten island | 253 | 0.4% | |
| astoria | 238 | 0.4% | |
| Other values (123) | 1041 | 1.7% |
Unique
| Unique | 44 ? |
|---|---|
| Unique (%) | 0.1% |
Length
| Max length | 19 |
|---|---|
| Median length | 8 |
| Mean length | 8.014057903 |
| Min length | 2 |
host_id
Real number (ℝ≥0)
| Distinct | 47743 |
|---|---|
| Distinct (%) | 79.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31006954.44 |
|---|---|
| Minimum | 72 |
| Maximum | 129710473 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 72 |
|---|---|
| 5-th percentile | 505080.3 |
| Q1 | 5453285.25 |
| median | 19655896 |
| Q3 | 46679319.25 |
| 95-th percentile | 104113408 |
| Maximum | 129710473 |
| Range | 129710401 |
| Interquartile range (IQR) | 41226034 |
Descriptive statistics
| Standard deviation | 32167333.99 |
|---|---|
| Coefficient of variation (CV) | 1.037423203 |
| Kurtosis | 0.6024662294 |
| Mean | 31006954.44 |
| Median Absolute Deviation (MAD) | 16496225.5 |
| Skewness | 1.224225418 |
| Sum | 1.854960042e+12 |
| Variance | 1.034737376e+15 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 30283594 | 228 | 0.4% | |
| 25188 | 158 | 0.3% | |
| 12243051 | 115 | 0.2% | |
| 9419684 | 99 | 0.2% | |
| 4962900 | 56 | 0.1% | |
| 22348222 | 50 | 0.1% | |
| 3965428 | 45 | 0.1% | |
| 8160186 | 44 | 0.1% | |
| 46630199 | 42 | 0.1% | |
| 33127842 | 38 | 0.1% | |
| Other values (47733) | 58949 | 98.5% |
| Value | Count | Frequency (%) | |
| 72 | 1 | < 0.1% | |
| 283 | 1 | < 0.1% | |
| 524 | 1 | < 0.1% | |
| 625 | 1 | < 0.1% | |
| 651 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 129710473 | 1 | < 0.1% | |
| 129638070 | 1 | < 0.1% | |
| 129600995 | 1 | < 0.1% | |
| 129474989 | 1 | < 0.1% | |
| 129332823 | 1 | < 0.1% |
| Distinct | 59824 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10071710.51 |
|---|---|
| Minimum | 590 |
| Maximum | 18670793 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 590 |
|---|---|
| 5-th percentile | 748367 |
| Q1 | 5477726 |
| median | 10227927.5 |
| Q3 | 15057850.5 |
| 95-th percentile | 17796455.7 |
| Maximum | 18670793 |
| Range | 18670203 |
| Interquartile range (IQR) | 9580124.5 |
Descriptive statistics
| Standard deviation | 5507014.656 |
|---|---|
| Coefficient of variation (CV) | 0.546780475 |
| Kurtosis | -1.185812616 |
| Mean | 10071710.51 |
| Median Absolute Deviation (MAD) | 4810926.5 |
| Skewness | -0.2351024259 |
| Sum | 6.025300094e+11 |
| Variance | 3.032721042e+13 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 11667455 | 1 | < 0.1% | |
| 9825448 | 1 | < 0.1% | |
| 2798787 | 1 | < 0.1% | |
| 12106946 | 1 | < 0.1% | |
| 9393343 | 1 | < 0.1% | |
| 14372028 | 1 | < 0.1% | |
| 16716983 | 1 | < 0.1% | |
| 14884022 | 1 | < 0.1% | |
| 66741 | 1 | < 0.1% | |
| 12782772 | 1 | < 0.1% | |
| Other values (59814) | 59814 | > 99.9% |
| Value | Count | Frequency (%) | |
| 590 | 1 | < 0.1% | |
| 592 | 1 | < 0.1% | |
| 686 | 1 | < 0.1% | |
| 930 | 1 | < 0.1% | |
| 1235 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 18670793 | 1 | < 0.1% | |
| 18669180 | 1 | < 0.1% | |
| 18668929 | 1 | < 0.1% | |
| 18668136 | 1 | < 0.1% | |
| 18668105 | 1 | < 0.1% |
instant_bookable
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 467.4 KiB |
| f | |
|---|---|
| t |
| Value | Count | Frequency (%) | |
| f | 47009 | 78.6% | |
| t | 12815 | 21.4% |
| Distinct | 59824 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.65136193 |
|---|---|
| Minimum | 38.82340343 |
| Maximum | 42.38998168 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 38.82340343 |
|---|---|
| 5-th percentile | 38.90649017 |
| Q1 | 40.67384822 |
| median | 40.72213316 |
| Q3 | 40.79182043 |
| 95-th percentile | 42.31594424 |
| Maximum | 42.38998168 |
| Range | 3.566578254 |
| Interquartile range (IQR) | 0.117972203 |
Descriptive statistics
| Standard deviation | 0.8620897317 |
|---|---|
| Coefficient of variation (CV) | 0.02120690896 |
| Kurtosis | 0.4889390524 |
| Mean | 40.65136193 |
| Median Absolute Deviation (MAD) | 0.05706147595 |
| Skewness | -0.3961068842 |
| Sum | 2431927.076 |
| Variance | 0.7431987054 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 42.36494498 | 1 | < 0.1% | |
| 40.7070066 | 1 | < 0.1% | |
| 42.33477464 | 1 | < 0.1% | |
| 40.74570464 | 1 | < 0.1% | |
| 40.57791276 | 1 | < 0.1% | |
| 41.94415754 | 1 | < 0.1% | |
| 40.80757541 | 1 | < 0.1% | |
| 40.71812503 | 1 | < 0.1% | |
| 41.91423342 | 1 | < 0.1% | |
| 40.73196253 | 1 | < 0.1% | |
| Other values (59814) | 59814 | > 99.9% |
| Value | Count | Frequency (%) | |
| 38.82340343 | 1 | < 0.1% | |
| 38.82340766 | 1 | < 0.1% | |
| 38.82721018 | 1 | < 0.1% | |
| 38.8274506 | 1 | < 0.1% | |
| 38.82805248 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 42.38998168 | 1 | < 0.1% | |
| 42.3898975 | 1 | < 0.1% | |
| 42.38982827 | 1 | < 0.1% | |
| 42.38968173 | 1 | < 0.1% | |
| 42.38953063 | 1 | < 0.1% |
| Distinct | 59824 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -76.67488126 |
|---|---|
| Minimum | -105.0945635 |
| Maximum | -71.00009992 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | -105.0945635 |
|---|---|
| 5-th percentile | -87.71004057 |
| Q1 | -76.98172548 |
| median | -73.97298437 |
| Q3 | -73.9427197 |
| 95-th percentile | -71.11697839 |
| Maximum | -71.00009992 |
| Range | 34.09446357 |
| Interquartile range (IQR) | 3.039005775 |
Descriptive statistics
| Standard deviation | 7.139988924 |
|---|---|
| Coefficient of variation (CV) | -0.09312031275 |
| Kurtosis | 7.866628444 |
| Mean | -76.67488126 |
| Median Absolute Deviation (MAD) | 0.03378550895 |
| Skewness | -2.859506855 |
| Sum | -4586998.097 |
| Variance | 50.97944183 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| -73.91185662 | 1 | < 0.1% | |
| -73.93745568 | 1 | < 0.1% | |
| -87.70502505 | 1 | < 0.1% | |
| -73.97199766 | 1 | < 0.1% | |
| -73.97925194 | 1 | < 0.1% | |
| -73.98528222 | 1 | < 0.1% | |
| -73.92960173 | 1 | < 0.1% | |
| -73.95366862 | 1 | < 0.1% | |
| -87.68822335 | 1 | < 0.1% | |
| -73.93829415 | 1 | < 0.1% | |
| Other values (59814) | 59814 | > 99.9% |
| Value | Count | Frequency (%) | |
| -105.0945635 | 1 | < 0.1% | |
| -105.092001 | 1 | < 0.1% | |
| -105.0918164 | 1 | < 0.1% | |
| -105.0884251 | 1 | < 0.1% | |
| -105.0882193 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| -71.00009992 | 1 | < 0.1% | |
| -71.00026054 | 1 | < 0.1% | |
| -71.0003318 | 1 | < 0.1% | |
| -71.00038139 | 1 | < 0.1% | |
| -71.00074121 | 1 | < 0.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 467.4 KiB |
| NYC | |
|---|---|
| dc | |
| chicago | |
| boston | 3585 |
| denver | 2505 |
| Value | Count | Frequency (%) | |
| NYC | 40740 | 68.1% | |
| dc | 7787 | 13.0% | |
| chicago | 5207 | 8.7% | |
| boston | 3585 | 6.0% | |
| denver | 2505 | 4.2% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 7 |
|---|---|
| Median length | 3 |
| Mean length | 3.523385263 |
| Min length | 2 |
| Distinct | 58689 |
|---|---|
| Distinct (%) | 98.2% |
| Missing | 41 |
| Missing (%) | 0.1% |
| Memory size | 467.4 KiB |
| DRIFTER INN Rockaway Beach | 12 |
|---|---|
| Loft Suite @ The Box House Hotel | 11 |
| Private room | 11 |
| Private room in Brooklyn | 10 |
| East Village Studio | 9 |
| Other values (58684) |
| Value | Count | Frequency (%) | |
| DRIFTER INN Rockaway Beach | 12 | < 0.1% | |
| Loft Suite @ The Box House Hotel | 11 | < 0.1% | |
| Private room | 11 | < 0.1% | |
| Private room in Brooklyn | 10 | < 0.1% | |
| East Village Studio | 9 | < 0.1% | |
| Private room in Williamsburg | 8 | < 0.1% | |
| Lux 2BR by Fenway w/WiFi | 8 | < 0.1% | |
| CLEAN NEW YORK APT at Central Park | 8 | < 0.1% | |
| Cozy Rooms | 7 | < 0.1% | |
| Private Room in Williamsburg Loft | 7 | < 0.1% | |
| Other values (58679) | 59692 | 99.8% | |
| (Missing) | 41 | 0.1% |
Unique
| Unique | 57896 ? |
|---|---|
| Unique (%) | 96.8% |
Length
| Max length | 98 |
|---|---|
| Median length | 34 |
| Mean length | 34.23634327 |
| Min length | 1 |
price
Real number (ℝ≥0)
| Distinct | 697 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 159.0093775 |
|---|---|
| Minimum | 0 |
| Maximum | 10000 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 70 |
| median | 109 |
| Q3 | 176 |
| 95-th percentile | 400 |
| Maximum | 10000 |
| Range | 10000 |
| Interquartile range (IQR) | 106 |
Descriptive statistics
| Standard deviation | 236.200222 |
|---|---|
| Coefficient of variation (CV) | 1.485448379 |
| Kurtosis | 433.8907042 |
| Mean | 159.0093775 |
| Median Absolute Deviation (MAD) | 44 |
| Skewness | 15.2275995 |
| Sum | 9512577 |
| Variance | 55790.54487 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 100 | 2412 | 4.0% | |
| 150 | 2375 | 4.0% | |
| 75 | 1813 | 3.0% | |
| 60 | 1713 | 2.9% | |
| 50 | 1651 | 2.8% | |
| 200 | 1607 | 2.7% | |
| 80 | 1533 | 2.6% | |
| 65 | 1470 | 2.5% | |
| 125 | 1451 | 2.4% | |
| 70 | 1382 | 2.3% | |
| Other values (687) | 42417 | 70.9% |
| Value | Count | Frequency (%) | |
| 0 | 5 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 10 | 20 | < 0.1% | |
| 11 | 3 | < 0.1% | |
| 12 | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10000 | 2 | < 0.1% | |
| 9999 | 2 | < 0.1% | |
| 9998 | 1 | < 0.1% | |
| 9600 | 1 | < 0.1% | |
| 8000 | 1 | < 0.1% |
property_type
Categorical
| Distinct | 32 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Memory size | 467.4 KiB |
| Apartment | |
|---|---|
| House | |
| Condominium | 1723 |
| Townhouse | 1282 |
| Loft | 1109 |
| Other values (27) | 1091 |
| Value | Count | Frequency (%) | |
| Apartment | 46149 | 77.1% | |
| House | 8466 | 14.2% | |
| Condominium | 1723 | 2.9% | |
| Townhouse | 1282 | 2.1% | |
| Loft | 1109 | 1.9% | |
| Bed & Breakfast | 339 | 0.6% | |
| Other | 300 | 0.5% | |
| Guesthouse | 77 | 0.1% | |
| Dorm | 72 | 0.1% | |
| Timeshare | 43 | 0.1% | |
| Other values (22) | 260 | 0.4% |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 18 |
|---|---|
| Median length | 9 |
| Mean length | 8.404854239 |
| Min length | 3 |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14346 |
| Missing (%) | 24.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.738554906 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 10 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6628862042 |
|---|---|
| Coefficient of variation (CV) | 0.06806823092 |
| Kurtosis | 31.56654559 |
| Mean | 9.738554906 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -4.444429459 |
| Sum | 442890 |
| Variance | 0.4394181197 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 10 | 36662 | 61.3% | |
| 9 | 6967 | 11.6% | |
| 8 | 1287 | 2.2% | |
| 6 | 233 | 0.4% | |
| 7 | 210 | 0.4% | |
| 4 | 55 | 0.1% | |
| 2 | 45 | 0.1% | |
| 5 | 18 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| (Missing) | 14346 | 24.0% |
| Value | Count | Frequency (%) | |
| 2 | 45 | 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 55 | 0.1% | |
| 5 | 18 | < 0.1% | |
| 6 | 233 | 0.4% |
| Value | Count | Frequency (%) | |
| 10 | 36662 | 61.3% | |
| 9 | 6967 | 11.6% | |
| 8 | 1287 | 2.2% | |
| 7 | 210 | 0.4% | |
| 6 | 233 | 0.4% |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14280 |
| Missing (%) | 23.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.289785702 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 9 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.066888909 |
|---|---|
| Coefficient of variation (CV) | 0.1148453736 |
| Kurtosis | 9.924981715 |
| Mean | 9.289785702 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.530994196 |
| Sum | 423094 |
| Variance | 1.138251945 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 10 | 25105 | 42.0% | |
| 9 | 13274 | 22.2% | |
| 8 | 4790 | 8.0% | |
| 7 | 1117 | 1.9% | |
| 6 | 804 | 1.3% | |
| 4 | 184 | 0.3% | |
| 2 | 145 | 0.2% | |
| 5 | 107 | 0.2% | |
| 3 | 18 | < 0.1% | |
| (Missing) | 14280 | 23.9% |
| Value | Count | Frequency (%) | |
| 2 | 145 | 0.2% | |
| 3 | 18 | < 0.1% | |
| 4 | 184 | 0.3% | |
| 5 | 107 | 0.2% | |
| 6 | 804 | 1.3% |
| Value | Count | Frequency (%) | |
| 10 | 25105 | 42.0% | |
| 9 | 13274 | 22.2% | |
| 8 | 4790 | 8.0% | |
| 7 | 1117 | 1.9% | |
| 6 | 804 | 1.3% |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14285 |
| Missing (%) | 23.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.758624476 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 10 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6454399592 |
|---|---|
| Coefficient of variation (CV) | 0.06614046486 |
| Kurtosis | 34.08967804 |
| Mean | 9.758624476 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -4.637572603 |
| Sum | 444398 |
| Variance | 0.4165927409 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 10 | 37484 | 62.7% | |
| 9 | 6268 | 10.5% | |
| 8 | 1255 | 2.1% | |
| 7 | 210 | 0.4% | |
| 6 | 207 | 0.3% | |
| 4 | 45 | 0.1% | |
| 2 | 44 | 0.1% | |
| 5 | 24 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| (Missing) | 14285 | 23.9% |
| Value | Count | Frequency (%) | |
| 2 | 44 | 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 45 | 0.1% | |
| 5 | 24 | < 0.1% | |
| 6 | 207 | 0.3% |
| Value | Count | Frequency (%) | |
| 10 | 37484 | 62.7% | |
| 9 | 6268 | 10.5% | |
| 8 | 1255 | 2.1% | |
| 7 | 210 | 0.4% | |
| 6 | 207 | 0.3% |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14349 |
| Missing (%) | 24.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.463001649 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 9 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.8189236679 |
|---|---|
| Coefficient of variation (CV) | 0.08653952501 |
| Kurtosis | 9.417358201 |
| Mean | 9.463001649 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.288947515 |
| Sum | 430330 |
| Variance | 0.6706359739 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 10 | 27606 | 46.1% | |
| 9 | 13079 | 21.9% | |
| 8 | 3786 | 6.3% | |
| 7 | 526 | 0.9% | |
| 6 | 352 | 0.6% | |
| 4 | 55 | 0.1% | |
| 5 | 37 | 0.1% | |
| 2 | 30 | 0.1% | |
| 3 | 4 | < 0.1% | |
| (Missing) | 14349 | 24.0% |
| Value | Count | Frequency (%) | |
| 2 | 30 | 0.1% | |
| 3 | 4 | < 0.1% | |
| 4 | 55 | 0.1% | |
| 5 | 37 | 0.1% | |
| 6 | 352 | 0.6% |
| Value | Count | Frequency (%) | |
| 10 | 27606 | 46.1% | |
| 9 | 13079 | 21.9% | |
| 8 | 3786 | 6.3% | |
| 7 | 526 | 0.9% | |
| 6 | 352 | 0.6% |
| Distinct | 56 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 14200 |
| Missing (%) | 23.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 93.47475013 |
|---|---|
| Minimum | 20 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 80 |
| Q1 | 90 |
| median | 96 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 80 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 8.240907966 |
|---|---|
| Coefficient of variation (CV) | 0.08816186141 |
| Kurtosis | 15.70236035 |
| Mean | 93.47475013 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -2.9996797 |
| Sum | 4264692 |
| Variance | 67.9125641 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 100 | 12717 | 21.3% | |
| 93 | 3066 | 5.1% | |
| 96 | 3044 | 5.1% | |
| 95 | 2955 | 4.9% | |
| 98 | 2951 | 4.9% | |
| 97 | 2921 | 4.9% | |
| 90 | 2594 | 4.3% | |
| 80 | 2131 | 3.6% | |
| 94 | 2026 | 3.4% | |
| 92 | 1673 | 2.8% | |
| Other values (46) | 9546 | 16.0% | |
| (Missing) | 14200 | 23.7% |
| Value | Count | Frequency (%) | |
| 20 | 69 | 0.1% | |
| 27 | 2 | < 0.1% | |
| 30 | 2 | < 0.1% | |
| 40 | 96 | 0.2% | |
| 43 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 100 | 12717 | 21.3% | |
| 99 | 1531 | 2.6% | |
| 98 | 2951 | 4.9% | |
| 97 | 2921 | 4.9% | |
| 96 | 3044 | 5.1% |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14354 |
| Missing (%) | 24.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.384891137 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 9 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.8742559064 |
|---|---|
| Coefficient of variation (CV) | 0.09315567902 |
| Kurtosis | 13.21852094 |
| Mean | 9.384891137 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.680956495 |
| Sum | 426731 |
| Variance | 0.7643233898 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 10 | 24557 | 41.0% | |
| 9 | 16350 | 27.3% | |
| 8 | 3377 | 5.6% | |
| 6 | 492 | 0.8% | |
| 7 | 457 | 0.8% | |
| 4 | 119 | 0.2% | |
| 2 | 72 | 0.1% | |
| 5 | 43 | 0.1% | |
| 3 | 3 | < 0.1% | |
| (Missing) | 14354 | 24.0% |
| Value | Count | Frequency (%) | |
| 2 | 72 | 0.1% | |
| 3 | 3 | < 0.1% | |
| 4 | 119 | 0.2% | |
| 5 | 43 | 0.1% | |
| 6 | 492 | 0.8% |
| Value | Count | Frequency (%) | |
| 10 | 24557 | 41.0% | |
| 9 | 16350 | 27.3% | |
| 8 | 3377 | 5.6% | |
| 7 | 457 | 0.8% | |
| 6 | 492 | 0.8% |
room_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 467.4 KiB |
| Entire home/apt | |
|---|---|
| Private room | |
| Shared room | 1697 |
| Value | Count | Frequency (%) | |
| Entire home/apt | 32103 | 53.7% | |
| Private room | 26024 | 43.5% | |
| Shared room | 1697 | 2.8% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 13.58150575 |
| Min length | 11 |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 467.4 KiB |
| NY | |
|---|---|
| DC | |
| IL | |
| MA | 3585 |
| CO | 2505 |
| Other values (4) | 34 |
| Value | Count | Frequency (%) | |
| NY | 40738 | 68.1% | |
| DC | 7755 | 13.0% | |
| IL | 5207 | 8.7% | |
| MA | 3585 | 6.0% | |
| CO | 2505 | 4.2% | |
| MD | 31 | 0.1% | |
| MP | 1 | < 0.1% | |
| VT | 1 | < 0.1% | |
| NJ | 1 | < 0.1% |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
| Distinct | 949 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 46386 |
| Missing (%) | 77.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 856.4712011 |
|---|---|
| Minimum | 70 |
| Maximum | 14000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 467.4 KiB |
Quantile statistics
| Minimum | 70 |
|---|---|
| 5-th percentile | 295 |
| Q1 | 450 |
| median | 675 |
| Q3 | 1000 |
| 95-th percentile | 2000 |
| Maximum | 14000 |
| Range | 13930 |
| Interquartile range (IQR) | 550 |
Descriptive statistics
| Standard deviation | 712.8567769 |
|---|---|
| Coefficient of variation (CV) | 0.8323184435 |
| Kurtosis | 58.34743434 |
| Mean | 856.4712011 |
| Median Absolute Deviation (MAD) | 270 |
| Skewness | 5.312020859 |
| Sum | 11509260 |
| Variance | 508164.7844 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 500 | 664 | 1.1% | |
| 600 | 557 | 0.9% | |
| 1000 | 518 | 0.9% | |
| 400 | 488 | 0.8% | |
| 700 | 477 | 0.8% | |
| 450 | 413 | 0.7% | |
| 800 | 412 | 0.7% | |
| 350 | 376 | 0.6% | |
| 1200 | 342 | 0.6% | |
| 300 | 325 | 0.5% | |
| Other values (939) | 8866 | 14.8% | |
| (Missing) | 46386 | 77.5% |
| Value | Count | Frequency (%) | |
| 70 | 2 | < 0.1% | |
| 80 | 1 | < 0.1% | |
| 85 | 1 | < 0.1% | |
| 99 | 3 | < 0.1% | |
| 100 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 14000 | 3 | < 0.1% | |
| 13000 | 1 | < 0.1% | |
| 12000 | 1 | < 0.1% | |
| 10000 | 4 | < 0.1% | |
| 9149 | 1 | < 0.1% |
| Distinct | 474 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 826 |
| Missing (%) | 1.4% |
| Memory size | 467.4 KiB |
| 11211 | 2043 |
|---|---|
| 11206 | 1405 |
| 11221 | 1371 |
| 20002 | 1270 |
| 20009 | 1270 |
| Other values (469) |
| Value | Count | Frequency (%) | |
| 11211 | 2043 | 3.4% | |
| 11206 | 1405 | 2.3% | |
| 11221 | 1371 | 2.3% | |
| 20002 | 1270 | 2.1% | |
| 20009 | 1270 | 2.1% | |
| 10002 | 1241 | 2.1% | |
| 11216 | 1162 | 1.9% | |
| 20001 | 1148 | 1.9% | |
| 10009 | 1143 | 1.9% | |
| 11238 | 1054 | 1.8% | |
| Other values (464) | 45891 | 76.7% |
Unique
| Unique | 67 ? |
|---|---|
| Unique (%) | 0.1% |
Length
| Max length | 11 |
|---|---|
| Median length | 5 |
| Mean length | 5.326390746 |
| Min length | 1 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| accommodates | amenities | availability_30 | bathrooms | bed_type | bedrooms | beds | cancellation_policy | city | has_availability | host_id | id | instant_bookable | latitude | longitude | metropolitan | name | price | property_type | review_scores_checkin | review_scores_cleanliness | review_scores_communication | review_scores_location | review_scores_rating | review_scores_value | room_type | state | weekly_price | zipcode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2.0 | {"Cable TV","Wireless Internet","Air conditioning","Free parking on premises",Breakfast,"Pets live on this property",Cat(s),"Indoor fireplace",Heating,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"} | 24 | 1.0 | Real Bed | 1.0 | 1.0 | moderate | sunnysidebronx | NaN | 119445 | 7949480 | f | 40.852054 | -73.788680 | NYC | City Island Sanctuary relaxing BR & Bath w Parking | 99.0 | House | 10.0 | 10.0 | 10.0 | 10.0 | 100.0 | 10.0 | Private room | NY | NaN | 10464 |
| 1 | 4.0 | {TV,Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron} | 30 | 1.0 | Real Bed | 1.0 | 1.0 | flexible | sunnysidebronx | NaN | 9117975 | 16042478 | t | 40.853491 | -73.788607 | NYC | WATERFRONT STUDIO APARTMENT | 200.0 | Apartment | NaN | NaN | NaN | NaN | NaN | NaN | Private room | NY | NaN | 10464 |
| 2 | 4.0 | {TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Heating,Washer,Dryer} | 30 | 3.0 | Real Bed | 3.0 | 3.0 | strict | sunnysidebronx | NaN | 9815788 | 1886820 | f | 40.841144 | -73.783052 | NYC | Quaint City Island Community. | 300.0 | House | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | NY | NaN | 10464 |
| 3 | 3.0 | {TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron} | 8 | 1.0 | Real Bed | 1.0 | 1.0 | strict | long island city | NaN | 13886510 | 6627449 | f | 40.849775 | -73.786609 | NYC | Large 1 BDRM in Great location | 125.0 | Apartment | 10.0 | 10.0 | 10.0 | 10.0 | 93.0 | 10.0 | Entire home/apt | NY | 775.0 | 10464 |
| 4 | 4.0 | {Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Pets allowed",Gym,Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit",Essentials,"Laptop friendly workspace","translation missing: en.hosting_amenity_50"} | 17 | 1.0 | Real Bed | 1.0 | 1.0 | moderate | sunnysidebronx | NaN | 28811542 | 5557381 | t | 40.850024 | -73.789328 | NYC | Quaint City Island Home | 69.0 | House | 10.0 | 10.0 | 10.0 | 10.0 | 97.0 | 10.0 | Private room | NY | 350.0 | 10464 |
| 5 | 2.0 | {TV,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self Check-In",Lockbox} | 23 | 1.0 | Real Bed | 0.0 | 1.0 | moderate | sunnysidebronx | NaN | 403032 | 9147025 | f | 40.844870 | -73.789541 | NYC | Cozy City Island Cottage | 125.0 | House | 10.0 | 10.0 | 10.0 | 10.0 | 97.0 | 10.0 | Entire home/apt | NY | 550.0 | 10464 |
| 6 | 4.0 | {TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 15 | 1.0 | Real Bed | 1.0 | 2.0 | flexible | long island city | NaN | 56714504 | 11675715 | t | 40.851391 | -73.784139 | NYC | Cozy 1 BR Basement Apartment | 85.0 | House | 10.0 | 10.0 | 10.0 | 10.0 | 98.0 | 10.0 | Entire home/apt | NY | NaN | 10464 |
| 7 | 3.0 | {"Cable TV",Internet,"Wireless Internet","Air conditioning",Kitchen,"Family/kid friendly","Smoke detector","First aid kit","Fire extinguisher"} | 5 | 1.0 | Real Bed | 1.0 | 2.0 | strict | sunnysidebronx | NaN | 3684360 | 715270 | f | 40.859559 | -73.870669 | NYC | 2 Beds/Queen & Full Beautiful Room 40 minsT.Square | 39.0 | Apartment | 9.0 | 9.0 | 9.0 | 9.0 | 90.0 | 9.0 | Private room | NY | NaN | 10467 |
| 8 | 5.0 | {TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Heating,"Smoke detector","Carbon monoxide detector",Essentials,Hangers,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Self Check-In",Keypad,"Private entrance"} | 17 | 1.0 | Real Bed | 1.0 | 1.0 | moderate | sunnysidebronx | NaN | 11305944 | 17876530 | f | 40.868682 | -73.854828 | NYC | Spacious Garden Apartment | 95.0 | House | 10.0 | 10.0 | 10.0 | 10.0 | 100.0 | 10.0 | Entire home/apt | NY | NaN | 10469 |
| 9 | 8.0 | {TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Pets allowed",Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 12 | 1.0 | Real Bed | 1.0 | 3.0 | strict | sunnysidebronx | NaN | 873273 | 182177 | t | 40.864658 | -73.857087 | NYC | PRIVATE FLAT / APARTMENT- $SPECIAL$ | 125.0 | Apartment | 10.0 | 9.0 | 10.0 | 9.0 | 92.0 | 9.0 | Entire home/apt | NY | NaN | 10469 |
Last rows
| accommodates | amenities | availability_30 | bathrooms | bed_type | bedrooms | beds | cancellation_policy | city | has_availability | host_id | id | instant_bookable | latitude | longitude | metropolitan | name | price | property_type | review_scores_checkin | review_scores_cleanliness | review_scores_communication | review_scores_location | review_scores_rating | review_scores_value | room_type | state | weekly_price | zipcode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59814 | 4.0 | {TV,"Cable TV",Internet,"Wireless Internet",Kitchen,"Free parking on premises","Family/kid friendly","Smoke detector",Essentials,"Private entrance"} | 0 | 1.5 | Real Bed | 2.0 | 2.0 | flexible | bethesda | NaN | 53010063 | 17962113 | t | 38.938794 | -77.119503 | dc | DC 10mins CHERRY BLOSSOM Festival Nice PrivateHome | 65.0 | House | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | MD | NaN | 20816 |
| 59815 | 1.0 | {TV,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Breakfast,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector",Essentials,Iron} | 27 | 1.0 | Real Bed | 0.0 | 1.0 | flexible | mount rainier | NaN | 126423287 | 18342528 | t | 38.944272 | -76.968505 | dc | Perfect living space 10 mins from downtown D.C. | 50.0 | Apartment | 10.0 | 10.0 | 10.0 | 10.0 | 100.0 | 10.0 | Private room | MD | NaN | 20712 |
| 59816 | 8.0 | {TV,"Wireless Internet",Kitchen,"Free parking on premises",Gym,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 0 | 3.5 | Real Bed | 3.0 | 4.0 | strict | bethesda | NaN | 16290768 | 18540842 | f | 38.949256 | -77.102368 | dc | Entire house, close to Friendship Heights/Bethesda | 225.0 | House | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | MD | NaN | 20816 |
| 59817 | 6.0 | {TV,"Wireless Internet","Air conditioning",Kitchen,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo} | 24 | 2.0 | Real Bed | 3.0 | 3.0 | flexible | hyattsville | NaN | 127411461 | 18393534 | t | 38.947872 | -76.975137 | dc | Hyattsville House - Seconds from D.C. | 240.0 | House | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | MD | NaN | 20782 |
| 59818 | 2.0 | {TV,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Pets allowed",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private living room"} | 28 | 1.0 | Real Bed | 1.0 | 1.0 | flexible | washington | NaN | 127837019 | 18442194 | t | 38.855900 | -76.950383 | dc | Cozy Townhome | 37.0 | House | NaN | NaN | NaN | NaN | NaN | NaN | Private room | DC | NaN | 20020 |
| 59819 | 2.0 | {Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises",Gym,"Hot tub",Heating,Washer,"Fire extinguisher",Essentials,Shampoo,Iron,"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"} | 0 | 1.0 | Real Bed | 1.0 | 1.0 | flexible | silver spring | NaN | 84708427 | 16232278 | t | 38.993370 | -77.036706 | dc | Friendly Warm & Clean Atmosphere | 42.0 | Apartment | 9.0 | 8.0 | 9.0 | 8.0 | 80.0 | 9.0 | Private room | MD | NaN | 20910 |
| 59820 | 5.0 | {TV,"Cable TV","Wireless Internet","Air conditioning",Kitchen,Gym,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"Hair dryer","Private entrance","Babysitter recommendations","Pack ’n Play/travel crib"} | 20 | 1.0 | Real Bed | 1.0 | 2.0 | flexible | bethesda | NaN | 16290768 | 18560601 | f | 38.951068 | -77.100468 | dc | Spacious and modern basement suite | 155.0 | Apartment | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | MD | NaN | 20816 |
| 59821 | 6.0 | {TV,Internet,"Wireless Internet","Air conditioning",Kitchen,"Free parking on premises","Smoking allowed",Heating,"Family/kid friendly","Smoke detector","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 13 | 1.0 | Real Bed | 1.0 | 3.0 | strict | temple hills | NaN | 31818247 | 17792195 | t | 38.840824 | -76.969784 | dc | Master room with parking near Metro | 75.0 | House | NaN | NaN | NaN | NaN | NaN | NaN | Private room | MD | NaN | 20748 |
| 59822 | 2.0 | {TV,"Cable TV",Internet,"Wireless Internet","Air conditioning",Pool,Kitchen,Doorman,Gym,"Elevator in building",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Fire extinguisher",Essentials,Shampoo,Hangers,Iron,"Laptop friendly workspace","Private entrance",Bathtub} | 12 | 1.0 | Real Bed | 1.0 | 1.0 | moderate | silver spring | NaN | 41071649 | 18223756 | t | 38.991331 | -77.028024 | dc | Modern Condo 5 min from DC | 115.0 | Condominium | 10.0 | 9.0 | 10.0 | 10.0 | 100.0 | 10.0 | Entire home/apt | MD | NaN | 20910 |
| 59823 | 2.0 | {TV,Internet,"Wireless Internet","Air conditioning",Kitchen,Heating,"Family/kid friendly","Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Shampoo,Hangers,"Hair dryer",Iron} | 24 | 1.0 | Real Bed | 1.0 | 1.0 | flexible | capitol heights | NaN | 23405709 | 18364166 | f | 38.885421 | -76.916581 | dc | Great PRV 1bd/1bath 2blocks to DC | 0.0 | House | NaN | NaN | NaN | NaN | NaN | NaN | Private room | MD | NaN | 20743 |